forum

home / developersection / forums / how to select record from excel spreadsheet in c#?

Ask Question

How to select record from excel spreadsheet in C#?

Pravesh Singh 8349 17-Aug-2012
Hello Everyone,
Can anyone tell me how to select record from excel spreadsheet using c# code?
c# c# 
Updated on 03-Dec-2013
Pravesh Singh

Other

Student

Follow
Can you answer this question?
Answer

3 Answers

Nibaal Bazzi

Nibaal Bazzi

03-Dec-2013
Hi Pravesh,
you can also try this C# Excel library, it provides a neat and an efficient API's for various spreadsheet files manipulations.
Here is a small sample how you can read an Excel file in C# and retrieve the values from the selected cell.
public object GetSelectedRecord(string fileName, string cellName)
{
    var file = ExcelFile.Load(fileName);
    var sheet = file.Worksheets.ActiveWorksheet;
    var cell = sheet.Cells[cellName];
    return cell.Value;
}

I hope this helps.

Sohail Shaikh

Sohail Shaikh

29-Nov-2012
http://blueraiden.exofire.net/blog/import-excel-spreadsheet-data-to-datagridview-using-vb-net
AVADHESH PATEL

AVADHESH PATEL

18-Aug-2012
Hello Pravesh
 
You can use the following code to selecting record from excel spreadsheet in c#

// Create Data Table for MS-Office 2007 or 2003
            System.Data.DataTable dtExcel = new System.Data.DataTable();
            //DataTable Name
            dtExcel.TableName = "MyExcelData";
            //Path of excel file 
            string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='F:\avi\information.xlsx';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
            //connectin
            OleDbConnection con = new OleDbConnection(SourceConstr);
            //Query string
            string query = "Select * from [Sheet1$]";
            //DataAdapter object
            OleDbDataAdapter data = new OleDbDataAdapter(query, con);
            //fill record into DataTable
            data.Fill(dtExcel);


Now you can bind DataTable with control for displaying record. You may check following link too.

http://www.mindstick.com/Blog/294/How%20to%20import%20or%20export%20SQL%20Server%20table%20data%20in%20MS%20Excel%20sheet%20using%20C%2023%20Code


I hope it might be resolve your problem.

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy